package cj.web.prize.dao;

/*
 *  
 *  
 */
import java.util.List;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;
import net.paoding.rose.jade.annotation.SQLParam;
import cj.web.prize.domain.PrizeResult;

/**
 * 
 * @author
 *
 */
@DAO
public interface PrizeResultDAO {
	
	@SQL("SELECT * FROM PrizeResult WHERE DeviceID=:1 AND ActiveID=:2")
	List<PrizeResult> queryByDeviceID(String DeviceID, String ActiveID);

	@SQL("INSERT INTO PrizeResult (ActiveID,Phone,DeviceID,DeviceType,CreateAT,Status,Remark) "
			+ "VALUES (:t.ActiveID,:t.Phone,:t.DeviceID,:t.DeviceType,now(),:t.Status,:t.Remark)")
	void create(@SQLParam("t") PrizeResult PrizeResult);
}